home *** CD-ROM | disk | FTP | other *** search
- *** NEWQTR.DBF (v. 2.6)
- *** TO CREATE QTRx.DBF FOR CURRENT PERIOD
- *** for PERSPAY.PRG (v 2.2)
- *** Copyright @ 1987, Martin J. Michaelson
- CLEAR
- SET TALK OFF
- SET BELL ON
- STORE SPACE(1) TO QTR
- SELECT 1
- USE
- @ 1,15 SAY "CREATING DATA BASE FOR CURRENT QUARTER"
- @ 3,20 SAY "CURRENT PAYROLL QUARTER ? " GET QTR
- READ
- USE QTR1
- COPY STRU TO QTR&QTR
- USE PAY_PERS
- COPY TO TEMP FIELDS EMP_NMBR FOR END_DATE=' '
- USE QTR&QTR
- APPE FROM TEMP
- INDEX ON EMP_NMBR TO QTREMP&QTR
- SELECT 1
- USE PAY_PERS INDEX EMPNO,PERSONS,DEPT
- RETURN